#region License

/* Copyright (c) 2008, Dusty Candland
 * 
 * All rights reserved.
 * 
 * Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
 * * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
 * * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
 * * Neither the name of Dusty Candland nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
 * 
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */

#endregion

using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data.SQLite;

namespace NS3Library.SQLite
{
    internal class MetaDataRepository : BaseRepository
    {
        private const string CREATE_TABLE =
            @"CREATE TABLE IF NOT EXISTS metadata (id INTEGER PRIMARY KEY AUTOINCREMENT, object_id INTEGER, 
			key TEXT, value TEXT);";

        private const string INSERT = "insert into metadata (object_id, key, value) values (@object_id, @key, @value)";
        private const string DELETE_FOR_OBJECT_ID = "delete from metadata where object_id = @id";
        private const string SELECT_FOR_OBJECT_ID = "select * from metadata where object_id = @object_id";

        public MetaDataRepository(string connectionString) : base(connectionString)
        {
        }

        public void EnsureMetaDataTable()
        {
            ExecuteNonQuery(CREATE_TABLE);
        }

        public void Save(int id, NameValueCollection metadata)
        {
            Delete(id);

            if (metadata == null)
                return;

            foreach (string key in metadata.Keys)
            {
                ExecuteNonQuery(INSERT,
                                new SQLiteParameter("@object_id", id),
                                new SQLiteParameter("@key", key),
                                new SQLiteParameter("@value", metadata[key]));
            }
        }

        public void Delete(int id)
        {
            ExecuteNonQuery(DELETE_FOR_OBJECT_ID, new SQLiteParameter("@id", id));
        }

        public NameValueCollection Get(int objectId)
        {
            IEnumerable<KeyValuePair<string, string>> pairs = ExecuteReader(SELECT_FOR_OBJECT_ID,
                                                                            SQLiteS3Parser.ParseKeyValuePairsDelegate,
                                                                            new SQLiteParameter("@object_id", objectId));

            var collection = new NameValueCollection();
            foreach (KeyValuePair<string, string> pair in pairs)
                collection.Add(pair.Key, pair.Value);
            return collection;
        }
    }
}